EASY30HED1 Use this to plot lottery results
Andrew Woods
'National Lottery Worksheet
'Draws
'Lottery Numbers
"CHECK7
=@SUM(B5:AX5)
'FREQUENCY
=@SUM(B5:B28)
=@SUM(C5:C28)
=@SUM(D5:D28)
=@SUM(E5:E28)
=@SUM(F5:F28)
=@SUM(G5:G28)
=@SUM(H5:H28)
=@SUM(I5:I28)
=@SUM(J5:J28)
=@SUM(K5:K28)
=@SUM(L5:L28)
=@SUM(M5:M28)
=@SUM(N5:N28)
=@SUM(O5:O28)
=@SUM(P5:P28)
=@SUM(Q5:Q28)
=@SUM(R5:R28)
=@SUM(S5:S28)
=@SUM(T5:T28)
=@SUM(U5:U28)
=@SUM(V5:V28)
=@SUM(W5:W28)
=@SUM(X5:X28)
=@SUM(Y5:Y28)
=@SUM(Z5:Z28)
=@SUM(AA5:AA28)
=@SUM(AB5:AB28)
=@SUM(AC5:AC28)
=@SUM(AD5:AD28)
=@SUM(AE5:AE28)
=@SUM(AF5:AF28)
=@SUM(AG5:AG28)
=@SUM(AH5:AH28)
=@SUM(AI5:AI28)
=@SUM(AJ5:AJ28)
=@SUM(AK5:AK28)
=@SUM(AL5:AL28)
=@SUM(AM5:AM28)
=@SUM(AN5:AN28)
=@SUM(AO5:AO28)
=@SUM(AP5:AP28)
=@SUM(AQ5:AQ28)
=@SUM(AR5:AR28)
=@SUM(AS5:AS28)
=@SUM(AT5:AT28)
=@SUM(AU5:AU28)
=@SUM(AV5:AV28)
=@SUM(AW5:AW28)
=@SUM(AX5:AX28)
=@SUM(B6:AX6)
=@SUM(B7:AX7)
=@SUM(B8:AX8)
=@SUM(B9:AX9)
=@SUM(B10:AX10)
=@SUM(B11:AX11)
=@SUM(B12:AX12)
=@SUM(B13:AX13)
=@SUM(B14:AX14)
=@SUM(B15:AX15)
=@SUM(B16:AX16)
=@SUM(B17:AX17)
=@SUM(B18:AX18)
=@SUM(B19:AX19)
=@SUM(B20:AX20)
=@SUM(B21:AX21)
=@SUM(B22:AX22)
=@SUM(B23:AX23)
=@SUM(B24:AX24)
=@SUM(B25:AX25)
=@SUM(B26:AX26)
=@SUM(B28:AX28)
+=@IF(@MOD(@SUM(AY5:AY28),7)=0,"OK","ERROR")
=@SUM(B27:AX27)
!="Weeks: "+@STR(@SUM(AY5:AY28)/7)
'NUMBERS
NOTE2
The CHECK7 column should ALWAYS have 7 in it, if any other
number appears then you have not entered all the numbers for
this draw.NOTE2
Check this cell after you have entered all your draws. If
you have entered to few numbers (ie. not a multiple of 7) then
the text ERROR will appear. If everything is alright then
the word OK will appear.PALL
GRAFLottery Number Frequency